﻿
CREATE PROCEDURE [dbo].[SYS_Provider_GetModel]
(
	@ProviderId  int
)

AS

SELECT TOP 1
	p.[ProviderId],
	p.[ProviderTypeId],
	p.[Name],
	p.[Description],
	p.[ConfigurationControlPath],
	p.[Status]
	FROM dbo.SYS_Provider p 
	WHERE p.[ProviderId] = @ProviderId

